If you enter a number in the Date, Time or Date and time format in a cell, the cell is automatically assigned the Date, Time or Date and time format respectively.
|
|
|
A number formatted as Date
|
A number formatted as Time
|
A number formatted as
Date and time
|
